Equinox Online Help

Home

String handling

Statement/FunctionDescription
AfterStr [Function] Returns the contents of a string that comes after a search string
AfterStr [Statement] Replaces the contents of a string that comes after a search string
BeforeStr [Function] Returns the contents of a string that comes before a search string
BeforeStr [Statement] Replaces the contents of a string that comes before a search string
Len
BeginsWith Returns the true if the left operand begins with the right operand
Left [Statement]
BetweenStr [Function] Returns the contents of a string that comes between Before string and after string
Left [Function] Returns left-hand string segment
BetweenStr [Statement] Replaces the contents of a string that comes between Before string and after string
ChrList Searches string for character matches
Chrs Returns string filled with specified characters
Compare Returns similarity [0-100]% of two strings
Fill Fills string with characters
EndsWith Returns true if the left operand ends with the right operand.
IsNumber Checks if string contains digits
Match Checks if two strings are equivalent
Maxlen Returns maximum length of string
Mid [Function] Returns string segment
Mid [Statement]
Remove Removes segment from string
Replace Replaces segment in string
Right [Function] Returns right-hand string segment
Right [Statement]
Search / SearchNext Searches for segment in string
SubstituteData Merges record data with memo variables
SetLen Changes string length by character-padding
SetMaxLen Sets maximum length of memo field
SortOrder Returns string sorted alphabetically